| |
56 Search Results Found |
| 1 |
Forum: Reports & Discoverer «»
Posted on: Wed, 08 March 2017 18:22 «»
By: nugraha.perdana2390
REP-1401: 'afterpform': Fatal PL/SQL error occurred. ORA-06502: PL/SQL: numeric or value error
…will display parameter sql developer this logic, help me true logic
select
prp.note_to_receiver,
prp.pr_description,
prp.no_pr,
prp.pr_line,
prp.pr_item,
prp.pr_item_desc,
prp.req_line_quantity,
prp.pr_uom,
prp.need_by_date…
|
| 2 |
Forum: Performance Tuning «»
Posted on: Sat, 28 November 2015 04:27 «»
By: John Watson
Re: Testing SPM
…description of how SPM works is correct. I do not see the problem: SPM is intended to stabilize the system. Any changes are help back until they have been verified, which you have to do manually in your release. I usually automate the process to evolve …
|
| 3 |
Forum: Performance Tuning «»
Posted on: Mon, 03 August 2015 07:15 «»
By: grpatwari
Help to tune the query
…All,
I would like to tune the query as part of my assignment. Please help me to tune this query.
Click here
SELECT distinct INV.NAME,
INV.ID,
INV.MANAGER_ID AS MANAGER_ID,
ODF_PR.ERI_CFR AS CFR ,
(SELECT NVL(SUM(BMS_PAST_DUE),0…
|
| 4 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Mon, 04 May 2015 13:22 «»
By: John Watson
Re: Need Oracle EBS installation in desktop
…are many people (including me) who could do this for you, but you need to provide a bit more information. For example:
Do you need me to download the sotfware for you?
Do you you want the Vision demo database installed, or a production database?
What…
|
| 5 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Thu, 09 April 2015 03:22 «»
By: chris212
Re: Oracle Financial API
…you looking to develop a new API or just need a platform to extract your required info. If you want the full meal deal (complete solution from a financial market data provider), then you might want to look at http://www.barchartondemand.com.com/web-…
|
| 6 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Thu, 25 September 2014 14:50 «»
By: jamalfarooq
Create OLM course by using API
…Guru,
I am new in Oracle OLM, I have one assignment in which I have to load course into Oracle OLM by using API, I found one API which called "OTA_ACTIVITY_VERSION_API.CREATE_ACTIVITY_VERSION" but it's given me ORA-20001: …
|
| 7 |
Forum: Forms «»
Posted on: Mon, 03 March 2014 04:06 «»
By: mist598
Re: Messages
…is no PK,FK and UNIQUE Keys , Inventory_item_id,organization_id
CREATE TABLE and CREATE VIEW
CREATE TABLE REGAL_INV_LANDED_COST_TAB
(
PO_NUMBER VARCHAR2(30 BYTE),
FILE_NUMBER VARCHAR2(30 BYTE),
ITEM_NUMBER…
|
| 8 |
Forum: Forms «»
Posted on: Tue, 29 October 2013 06:29 «»
By: m_shehpar
Re: issue with form trigger failure
…me if i am wrong bro... timer is the only way to use restricted built-ins while in when-validate_item triggers....
below is the code which i have written in the when-timer-expire popping up from validate item trigger. there is no other way i could …
|
| 9 |
Forum: Forms «»
Posted on: Tue, 29 October 2013 05:40 «»
By: m_shehpar
Re: issue with form trigger failure
…your help guided my through the right path, but still i am facing wearied responses.
can you please have a look on the below code which i have written on the when-validate-item trigger. Problem is, when the condition for "RAISE …
|
| 10 |
Forum: Forms «»
Posted on: Mon, 28 October 2013 05:14 «»
By: m_shehpar
Re: issue with form trigger failure
…cookiemonster for your attention. following is the scenerio
** i got 3 columns relevant here, unit_amount, quantity and functional_amount (functional_amount is self computed by unit_amount * quantity)
** in validate trigger of functional amount, i …
|
| 11 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 02 November 2012 00:47 «»
By: mgibson
Tricky SQL Issue...
…Forumers,
I've been writing low - mid level Oracle SQL for years, but I've never really had to write really complex stuff, but now I'm faced with a challenge that's very tricky (for me anyway). I'm trying to implement some security into a 3rd party …
|
| 12 |
Forum: RAC & Failsafe «»
Posted on: Tue, 07 August 2012 06:03 «»
By: John Watson
Re: REGARDING RAC SETUP
…are many possible ways. It depends on your hardware, operating system, requirements, budget, standards, numerous factors. Perhaps someone here can help, but really I think it is beyond the scope of a forum question. If you would like consultancy, let me …
|
| 13 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Wed, 01 August 2012 05:28 «»
By: Johndenger
Oracle Journals
This is used for only planning purpose.Planning Budget we will targets, System will not be controlling under this budget.
For planning budget we cannot create budget journals
Johnd
|
| 14 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 24 May 2012 03:22 «»
By: jimit_shaili
Re: How to find nearest integer, where mod returns 0
…Sir,
In my case I'm converting Kgs into Grams (Based on simple maths 1 Kgs = 1000 Gms) and it is only for simplify the problem. I may take 0.045 instead of 45, which looks little difficult for others. And my problem is not based on any table data, it is …
|
| 15 |
Forum: Server Utilities «»
Posted on: Thu, 12 April 2012 11:29 «»
By: samrush
second enclosure string not present in sqlldr
…everyone,
I am new to sqlldr and am facing a problem.
I have to load a .csv file(I have no control over the format) into my staging table one of the fields in the .csv is mapped to a coloumn with clob datatype(DESCRIPTION).
The data in the …
|
| 16 |
Forum: General «»
Posted on: Fri, 15 July 2011 13:51 «»
By: prax_14
Oracle standard edition one limitations for huge database
…day friends,
In my current project we are trying to implement new feature and considering using BLOB's for storing 200 mb metadata file. We trying to build the system so that we can store up 200,000 of these blob's and we are estimating the database …
|
| 17 |
Forum: Linux «»
Posted on: Thu, 03 March 2011 20:41 «»
By: Barbara Boehmer
Re: How to convert Blocks to MB
…following examples produce the space allocated to the table, which includes space that is not used. The value or block_size is the number of bytes per block. You multiply the blocks per table by bytes per block for your system, then divide by 1048576 …
|
| 18 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 16 February 2011 18:48 «»
By: Kevin Meade
Re: trigger efficiency
…Yes, one trigger will be marginally faster as was stated. This is in part due to less recursive calls that would be required. However the difference won't be important. You should instead concentrate on using triggers correctly.
I would suggest that…
|
| 19 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 08 April 2010 09:36 «»
By: pikku24
Re: How to remove nulls in select statement?
…following statement should return more than 300 columns but its returning 212 becuase it has nulls.
select column_name
from user_tab_columns
where table_name = 'MTL_SYSTEM_ITEMS_VL' AND trim(COLUMN_NAME) IN (
'TRANSACTION_TYPE' ,
'…
|
| 20 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Wed, 13 January 2010 13:26 «»
By: ny1001
Need suggestion in selecting Apex for new development
…Guys,
I came across oracle apex this week and started digging through the documentation and presentations. Read some forums as well. Now I believe, our application can be helpful by utilizing Apex but I would like to share high level application …
|
| 21 |
Forum: Server Utilities «»
Posted on: Tue, 29 December 2009 09:09 «»
By: stg2009
Re: How to "clean" Oracle database before importing
…for all of your quick replies. As an initial attempt, I have gone down Mahesh Rajendran's suggested path. I have deleted and re-created the Oracle database on machine A using DBCA.
On machine B, I did
select tablespace_name from …
|
| 22 |
Forum: Training & Certification «»
Posted on: Thu, 25 June 2009 15:04 «»
By: focusthread
OTL Advanced Benefits HRMS Training
…Thread is the Number 1 Online Oracle Apps Training company in the globe. Our low cost but high quality instructor lead trainings have received raving testimonials, see this link
www.focusthread.com/training/35-training-testimonials/87-training-
…
|
| 23 |
Forum: Marketplace «»
Posted on: Tue, 20 January 2009 13:09 «»
By: gperry
Oracle HRMS Consultant available (13yrs exp)
…waste your time and money working with vendors who are going to charge you over the top. Work directly with one of the most experienced Oracle HRMS consultants in the country. References available upon request.
Graham Perry
415-215-7180 (cell)
…
|
| 24 |
Forum: Marketplace «»
Posted on: Tue, 23 September 2008 11:55 «»
By: bushas
Oracle Applications DBA Position in Midwest U.S.
…Position: Oracle Applications DBA with 11i /12 experience
Location: Between Ann Arbor Michigan and Toledo Ohio
Salary/Wage:95,000.00 - 105,000.00 /year Full Time, Employee
Relocation Assistance is provided.
*Description:
Oracle …
|
| 25 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Sun, 25 November 2007 19:28 «»
By: aryanna
Oracle EBS 11i10:GL: DEFINE BUDGET ORG AND ACCOUNT ASSIGNMENT BUT BUDGET AMOUNT IS NOT UPLOADED.
…Hi,
I really need an urgent help on this matter.
We have define budget organization and account assignment but the budget amount is not uploaded. We have migrated and posted 5 month gl interface
data that required to do fund checking unfortunately …
|
| 26 |
Forum: Server Administration «»
Posted on: Wed, 17 October 2007 02:02 «»
By: alok_personal
ORA-342 & ORA-312
…Hi,
We have oracle 7 on machine. Our DBA just left and of
course the database died. Somehow I was elected to try and fix it, but
Im a software engineer, I know about oracle.but dont know like this problem...
When I run the startup script, I get …
|
| 27 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Tue, 25 September 2007 04:34 «»
By: praburajkumar
Re: Encumbrance
…
Hi Raju,
Encumbrance is a way in which we reserve funds for some liability which will occur in the future.
[IMPORTANT NOTE:-DONT TRY TO FIX UP A BUDGET AND TRY USING ENCUMBRANCE IF YOUR SYSTEM IS ALREADY IN PRODUCTION WHICH WILL AFFECT …
|
| 28 |
Forum: Forms «»
Posted on: Fri, 24 August 2007 02:57 «»
By: DaveCot
Re: hrlp FRM-40106 No navigable items
…David,
Yes i inherited if from the developer who was on the project before myself and my senior developer arrived. The senior devloper is unfortunately off on Annual Leave now and he has broken the application which was orginally 6 canvases all with …
|
| 29 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Wed, 11 April 2007 12:57 «»
By: cnubandi
Re: different phases in implementation
…Phases
AIM projects are conducted in phases. These phases provide quality and control checkpoints to coordinate project activities that have a common goal. During a project phase, your project team will
simultaneously be executing tasks from several …
|
| 30 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Mon, 26 March 2007 05:11 «»
By: David.K.Dickson
Re: validation rule?
…don't have access to a system, so I can't give you the navigation, but I will do what I can to help.
First of all, Journal out any Actual balances on the account and remove any Budget balances too.
Next, identify the source of any ongoing postings…
|
| 31 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 08 October 2006 02:06 «»
By: royal
Re: Abt Trigger
… I have tried to run the trigger again and it's giving me a new error....why can run at the 1st time and now cant?
Can anyone tell me where the mistake i made?
ERROR at line 1:
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-…
|
| 32 |
Forum: Server Administration «»
Posted on: Tue, 19 September 2006 00:40 «»
By: reyazan
oracle 9i Heterogeneous Services problem pls help
…have a BUDGET.mdb file in ms access2000 os windows2000 server.
I have create a system dsn odbc BUDGET for above mdb file using ms access driver.
I have oracle9i enterprise edition on windows 2000 server (database sid UDR on 1521 port).
Now i have perfo…
|
| 33 |
Forum: Marketplace «»
Posted on: Fri, 21 July 2006 12:59 «»
By: Generator
Oracle Applications Technical Lead (Portland, Oregon, USA)
…client is striving to build a safe, comfortable, reliable and innovative transit system that delivers transportation options to the greater Portland area. Recognized in their space as being a technology leader and early adopter they seek to provide …
|
| 34 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Fri, 26 May 2006 03:30 «»
By: vcsekhar.ca
Errer when running Funds Check Process
…all,
when i am creating budget journal the following error is displaying when i press the "Check Funds" tab in create budget juornal screen. what i have to do to rectify the error. please any one give solution for this.
"Error: APP-…
|
| 35 |
Forum: Marketplace «»
Posted on: Thu, 19 January 2006 16:43 «»
By: bushas
Oracle Applications Program Manager / Director Positions
…** You can be based anywhere for this position as long as you live near a major airport and
be willing to travel up to 100%.
However,target cities are San Francisco, Portland, Seattle, and Los Angeles/San Diego.
Position: Oracle Applications …
|
| 36 |
Forum: Marketplace «»
Posted on: Wed, 03 August 2005 21:32 «»
By: gperry
Oracle HRMS Manager looking for role in TX, CO, NC, GA
…Perry
415-215-7180 (cell)
graham_perry2000@yahoo.com
Experience Summary
IT professional with ten years software development and consulting experience, including product development/management of a $100 million/year Oracle software …
|
| 37 |
Forum: Marketplace «»
Posted on: Thu, 14 April 2005 04:18 «»
By: AlligatorSQL
AlligatorDBC: Cost-effective "Real time Business" out-of-the-box
…AlligatorDBC, multiple data sources can now be integrated "on demand" without the prep time or any interface programming going beyond the scope of the project budget. In the process, the systems are not joined as one static system, but are …
|
| 38 |
Forum: Server Utilities «»
Posted on: Thu, 25 November 2004 00:24 «»
By: hemanth
Re: How to run TKPROF on Oracle9i(9.0.1)
…SQL Trace and TKPROF
The SQL Trace facility and TKPROF are two basic performance diagnostic tools that can help you monitor and tune applications running against the Oracle Server.
This chapter contains the following sections:
· Understanding SQL Trace an…
|
| 39 |
Forum: Marketplace «»
Posted on: Sun, 27 June 2004 07:50 «»
By: Ashraf Seddeek
Full Time- Director, IT Finance PMO-West Coast, Consumer Electronics Company, SF Bay Area
…<Job> Full Time- Director, IT Finance PMO-West Coast, Consumer Electronics Company, SF Bay Area
***** When you respond to this opportunity, please be sure that the subject line of your email states: “Director, IT Finance PMO-West Coast” so that it …
|
| 40 |
Forum: Marketplace «»
Posted on: Sun, 27 June 2004 07:39 «»
By: Ashraf Seddeek
Full Time- Director, IT PMO-West Coast, Consumer Electronics Company, SF Bay Area
…<Job> Full Time- Director, IT PMO-West Coast, Consumer Electronics Company, SF Bay Area
***** When you respond to this opportunity, please be sure that the subject line of your email states: “Director, IT PMO-West Coast” so that it can be processe…
|
Blog
Search
Help
Members
Register
Login
Home